SELECT h.SalesOrderID, h.SalesPersonID, 
   d.OrderQty, d.ProductID, d.UnitPrice, 
   d.UnitPriceDiscount, d.LineTotal
FROM Sales.SalesOrderHeader h JOIN
   Sales.SalesOrderDetail d
   ON h.SalesOrderID = d.SalesOrderID
WHERE d.LineTotal > 10000
